package io.yizoo.business.mapper;

import org.apache.ibatis.annotations.Mapper;

import java.math.BigDecimal;
import java.util.List;
import java.util.Map;

@Mapper
public interface biz_analysis_cockpitMapper {

    //查询成本支出
    List<Map<String, Object>> SelectCostData(Map<String, Object> params);

    //查询收入统计
    List<Map<String, Object>> SelectIncomeData(Map<String, Object> params);

    //查询项目进度
    List<Map<String, Object>> SelectPjPlanData(Map<String, Object> params);

    //查询经营月表
    List<Map<String, Object>> SelectMonthTabData(Map<String, Object> params);

    //查询经营趋势
    List<Map<String, Object>> SelectBizTrendData(Map<String, Object> params);

    //查询经营月表汇总
    List<Map<String, Object>> SelectMonthData(Map<String, Object> params);

    //=====================
    //查询结算金额
    BigDecimal SelectJsData(Map<String, Object> params);

    //查询订单总额
    BigDecimal SelectDdTotalData(Map<String, Object> params);

    //查询合同总额
    BigDecimal SelectHtTotalData(Map<String, Object> params);

    //查询项目总额
    BigDecimal SelectPjTotalData(Map<String, Object> params);

    //查询项目承揽数量-按月份
    List<Map<String, Object>> SelectPjCountData(Map<String, Object> params);

    //查询指派进度
    List<Map<String, Object>> SelectRwzpData(Map<String, Object> params);

    //查询合同收入
    BigDecimal SelectHtSum(Map<String, Object> params);

    //查询订单收入
    BigDecimal SelectDDSum(Map<String, Object> params);

    //查询结算收入求和
    BigDecimal SelectJsSum(Map<String, Object> params);

    //查询报销金额求和
    BigDecimal SelectPjCostSum(Map<String, Object> params);

    //查询人工成本-薪酬 求和
    BigDecimal SelectLaborCostSum(Map<String, Object> params);

    //查询外委结算-支出合同 求和
    BigDecimal SelectOutsourceCostSum(Map<String, Object> params);

    //收入统计 - 合同收入 有效合同+有效订单
    List<Map<String, Object>> SelectHtIncomeData(Map<String, Object> params);

    //查询项目阶段
    Map<String, Object> SelectPjStageData(Map<String, Object> params);

    //查询总人数
    int SelectEICount();

    int SelectLeaveCount();

    int SelectTripCount();

    int SelectWorkCount();

    //查询请假中、出差中
    List<Map<String, Object>> SelectOnLeaveTripData(Map<String, Object> params);

    //查询请假中、出差中 人员工号
    List<String> SelectLeaveTripIds();

}
